package com.hhkj.admin.student.common.extend;

import cn.afterturn.easypoi.excel.annotation.Excel;
import com.ruoyi.common.utils.excl.annotation.Required;
import lombok.Data;

/**
 * 学员创建表格实体类
 *
 * @author
 */
@Data
public class StudentExcelModel {
    public static final Integer TITLE_HEIGHT = 1900;
    public static final Integer EXCEL_NAME_FONT_HEIGHT = 20;
    public static final Integer FILL_DATA_FONT_HEIGHT = 10;
    public final static String EXCEL_NAME = "学员导入模板";
    public final static String EXCEL_TITLE = "学员导入模板\n" +
            "1、红色字段姓名、身份证号码、考试科目为必填项" + "\n" +
            "2、填写内容时注意取消掉空格" + "\n" +
            "3、由于考试科目是表格录入，请检查录入科目的正确性" + "\n" +
            " ";

    /**
     * 学员名称
     */
    @Required
    @Excel(name = "姓名", width = 15, needMerge = true, orderNum = "0")
    private String name;

    /**
     * 身份证号码
     */
    @Required
    @Excel(name = "身份证号码", width = 25, needMerge = true, orderNum = "1")
    private String idCard;
    /**
     * 手机号
     */
    @Excel(name = "手机号", width = 15, needMerge = true, orderNum = "2")
    private String phone;

    /**
     * 考试科目名称
     */
    @Required
    @Excel(name = "考试科目", width = 35, needMerge = true, orderNum = "3")
    private String courseName;

    @Excel(name = "备注", width = 35, needMerge = true, orderNum = "4")
    private String remark;

    private Long courseId;
}
